/*
 Navicat Premium Data Transfer

 Source Server         : 
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : 127.0.0.1:13306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 50727
 File Encoding         : 65001

 Date: 12/10/2022 09:31:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for rule_list
-- ----------------------------
DROP TABLE IF EXISTS `rule_list`;
CREATE TABLE `rule_list` (
  `ID` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `rule_module` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '模块',
  `rule_group` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规则分组',
  `rule_code` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规则编码',
  `rule_content` varchar(3000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规则内容',
  `rule_version` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规则版本',
  `order_index` int(11) DEFAULT NULL COMMENT '执行排序顺序',
  `c_time` datetime DEFAULT NULL COMMENT '创建时间',
  `des` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of rule_list
-- ----------------------------
BEGIN;
INSERT INTO `rule_list` VALUES ('1', 'a', 'a', 'test1', '{\r\n			\"fun\":\"baseMath:form\",\r\n			\"funParam\":\"param.changeMode>a,param.bean.value,param.afterData>b,data.testdb.cCodes\",\r\n			\"resultName\":\"mathValue\",\r\n			\"funParamMap\":{\r\n			\"form\":\"([a]+[value])/10000-[b]\",\r\n			\"dec\":\"2\"\r\n			}\r\n		}', 'v1', 1, '2021-01-22 14:28:31', '描述');
INSERT INTO `rule_list` VALUES ('2', 'a', 'a', 'test2', '{\r\n			\"fun\":\"baseMath:form\",\r\n			\"funParam\":\"param.changeMode>a,param.bean.value,param.afterData>b\",\r\n			\"resultName\":\"mathValue2\",\r\n			\"funParamMap\":{\r\n			\"form\":\"([a]+[value])/10000-[b]\",\r\n			\"dec\":\"2\"\r\n			}\r\n		}', 'v1', 2, '2021-01-22 14:28:56', '描述2');
COMMIT;

-- ----------------------------
-- Table structure for rule_list_log
-- ----------------------------
DROP TABLE IF EXISTS `rule_list_log`;
CREATE TABLE `rule_list_log` (
  `id` varchar(50) NOT NULL,
  `change_mode` varchar(200) DEFAULT NULL COMMENT '修改模块',
  `before_data` text COMMENT '修改前',
  `after_data` text COMMENT '修改后',
  `c_time` datetime DEFAULT NULL,
  `c_name` varchar(255) DEFAULT NULL COMMENT '修改人账号',
  `c_type` varchar(255) DEFAULT NULL COMMENT 'update or del ',
  `c_groups` varchar(50) DEFAULT NULL COMMENT '对于sql groups',
  `c_codes` varchar(50) DEFAULT NULL COMMENT '对应sql codes',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='sql 管理平台日志记录';

-- ----------------------------
-- Records of rule_list_log
-- ----------------------------
BEGIN;
INSERT INTO `rule_list_log` VALUES ('1', '22', '22', '21', '2020-12-23 16:48:59', '2', '2', '2', '2');
INSERT INTO `rule_list_log` VALUES ('12', 'rewe', 'we', 'qwe', '2020-12-23 17:09:41', '2', '1', '2', '2');
INSERT INTO `rule_list_log` VALUES ('0ba100a8-3079-4d97-a6fe-088f3a01bf6c', 'task', '{\"codes\":\"test\",\"cCreator\":\"l\",\"paramKeys\":\"\",\"des\":\"测试\",\"groups\":\"test\",\"sqlContent\":\"SELECT * from sys_t_sql_log t WHERE 1=1 and t.change_mode = ? and t.before_data= ? and t.after_data LIKE \"%?%\"\",\"cTime\":\"2021-01-05 17:00:13\",\"id\":\"1\",\"tal\":\"task\"}', '{\"codes\":\"test\",\"cCreator\":\"test\",\"paramKeys\":\"\",\"des\":\"测试1\",\"groups\":\"test\",\"sqlContent\":\"SELECT * from sys_t_sql_log t WHERE 1=1 and t.change_mode = ? and t.before_data= ? and t.after_data LIKE \\\"%?%\\\"\",\"cTime\":\"2021-01-14 11:22:41\",\"id\":\"1\",\"tal\":\"task\"}', '2021-01-14 11:22:41', 'test', 'edit', 'test', 'test');
COMMIT;

-- ----------------------------
-- Table structure for sql_user
-- ----------------------------
DROP TABLE IF EXISTS `sql_user`;
CREATE TABLE `sql_user` (
  `user` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `passwd` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sql_user
-- ----------------------------
BEGIN;
INSERT INTO `sql_user` VALUES ('test', 'test');
INSERT INTO `sql_user` VALUES ('user', 'user');
COMMIT;

-- ----------------------------
-- Table structure for sys_api
-- ----------------------------
DROP TABLE IF EXISTS `sys_api`;
CREATE TABLE `sys_api` (
  `id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `api_group` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分组',
  `api_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编号',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
  `des` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',
  `sql_group` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'sql脚本分组',
  `sql_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'sql脚本code',
  `tal` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '标签分类，支持微服务模式',
  `api_param` varchar(3000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'code|name|must  编码|名称|是否必填',
  `rule_json` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规则',
  `model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '允许哪些接口，item,list,page,exe,update',
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '作者',
  `c_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_api
-- ----------------------------
BEGIN;
INSERT INTO `sys_api` VALUES ('1', 'test', 'test', 'test', 'test', 'test', 'test', 'task', '{\r\n	\"keys\":\"changeMode,beforeData,afterData,bean\",\r\n	\"mustKeys\":\"changeMode,beforeData,bean.value,bean.name,bean.user.name,bean.user.sex.one,bean.list:name,bean.list:cc\",\r\n	\"formatValue\":\"changeMode|text2|notNumber|have,beforeData|text2||haveAll,bean.user.name|text2|length20|haveAll,bean.list:name|text2|length20|haveAll\",\r\n	\"hintMust\":\"changeMode|----6666666--aaaaaaaaaa缺少模型参数,bean.list:name|list列表缺少名称\"\r\n}', NULL, 'webItem,webList,item,list', NULL, '2020-12-23 16:34:34');
INSERT INTO `sys_api` VALUES ('11', 'rule', 'test', '规则引擎测试', '规则引擎测试', NULL, NULL, 'task', '{\r\n	\"keys\":\"changeMode,beforeData,afterData,bean\",\r\n	\"mustKeys\":\"changeMode,beforeData,bean.value,bean.name,bean.user.name,bean.user.sex.one,bean.list:name,bean.list:cc\",\r\n	\"formatValue\":\"changeMode|text2|notNumber|have,beforeData|text2||haveAll,bean.user.name|text2|length20|haveAll,bean.list:name|text2|length20|haveAll\",\r\n	\"hintMust\":\"changeMode|缺少模型参数,bean.list:name|list列表缺少名称\"\r\n}', '{\r\n	\"jobs\":[\r\n		{\r\n			\"fun\":\"baseDb:insert\",\r\n			\"funParam\":\"param.changeMode>changeMode,param.beforeData>beforeData,#id#,#cTime#\",\r\n			\"resultName\":\"\",\r\n			\"dbParam\":\"\",\r\n			\"funParamMap\":{\r\n			\"table\":\"test1\"\r\n			}\r\n		},\r\n		{\r\n			\"fun\":\"baseDb:insert\",\r\n			\"funParam\":\"param.bean.user.name>name,param.bean.user.phone>phone,#id#,#cTime#\",\r\n			\"resultName\":\"\",\r\n			\"dbParam\":\"\",\r\n			\"funParamMap\":{\r\n			\"table\":\"test2\"\r\n			}\r\n		},\r\n		{\r\n			\"fun\":\"baseDb:item\",\r\n			\"funParam\":\"param.bean.user.name>name,param.bean.user.phone>phone,#id#,#cTime#\",\r\n			\"resultName\":\"testdb\",\r\n			\"dbParam\":\"test:test\"\r\n		}\r\n		,\r\n		{\r\n			\"fun\":\"task:test\",\r\n			\"funParam\":\"param.bean.user.name>name,param.bean.user.phone>phone,#id#,#cTime#\",\r\n			\"resultName\":\"taskTest\",\r\n			\"funParamMap\":{\r\n			\"name\":\"张三\"\r\n			}\r\n		},\r\n		{\r\n			\"fun\":\"task:test2\",\r\n			\"funParam\":\"param.bean.user.name>name,param.bean.user.phone>phone,#id#,#cTime#\",\r\n			\"resultName\":\"taskTest\",\r\n			\"funParamMap\":{\r\n			\"name\":\"张三\",\r\n			\"phone\":\"11111111111111111\"\r\n			}\r\n		},\r\n		{\r\n			\"fun\":\"task:test3\",\r\n			\"funParam\":\"param.bean.user.name>name,param.bean.user.phone>phone,#id#,#cTime#\",\r\n			\"resultName\":\"taskTest3\",\r\n			\"funParamMap\":{\r\n			\"name\":\"李四\",\r\n			\"phone\":\"11111111111111111\",\r\n			\"aaa\":\"----------李四\"\r\n			}\r\n		},\r\n		{\r\n			\"fun\":\"baseMath:form\",\r\n			\"funParam\":\"param.changeMode>a,param.bean.value,param.afterData>b,data.testdb.cCodes\",\r\n			\"resultName\":\"mathValue\",\r\n			\"funParamMap\":{\r\n			\"form\":\"(a+value)/10000-b+cCodes\",\r\n			\"dec\":\"2\"\r\n			}\r\n		},{\r\n			\"fun\":\"baseDb:insert\",\r\n			\"funParam\":\"param.changeMode>changeMode,data.mathValue>beforeData,#id#,#cTime#\",\r\n			\"resultName\":\"\",\r\n			\"dbParam\":\"\",\r\n			\"funParamMap\":{\r\n			\"table\":\"test1\"\r\n			}\r\n		}\r\n	],\r\n	\"dataKeys\":\"data>dataMap\"\r\n	\r\n}', 'run', 'tim', '2021-01-07 15:49:21');
INSERT INTO `sys_api` VALUES ('1222', 'test', 'testlist', '仿照批量处理计算', NULL, NULL, NULL, 'task', NULL, '{\r\n	\"jobs\":[\r\n		{\r\n			\"fun\":\"baseMath:formList\",\r\n			\"funParam\":\"param.afterData>aa\",\r\n			\"resultName\":\"aaa\",\r\n			\"dbParam\":\"\",\r\n			\"funParamMap\":{\r\n			\"listKey\":\"param.bean.list\",\r\n			\"form\":\"%s*%s*%s\",\r\n			\"tableKeys\":\"num,price,aa\"\r\n			}\r\n		}\r\n	],\r\n	\"dataKeys\":\"param>dataMap\"\r\n}', 'run', 'tim', '2021-01-21 19:53:30');
INSERT INTO `sys_api` VALUES ('2', 'task', 'getTaskLog', '获取定时任务日志', 'task', 'task', 'taskLog', 'task', NULL, NULL, 'webItem,webList,webPage,item,list,page', NULL, '2020-12-23 17:15:15');
INSERT INTO `sys_api` VALUES ('3', 'phone', 'insert', '插入数据', '插入数据', 'phone', 'insert', 'task', '', NULL, 'webExe,exe', NULL, '2020-12-23 21:32:38');
INSERT INTO `sys_api` VALUES ('3434s', 'test', 'file', 'test', 'excel导出', NULL, NULL, 'task', NULL, '{ \n	\"jobs\":[ \n		{ \n			\"fun\":\"poi:list\", \n			\"funParam\":\"\", \n			\"resultName\":\"\", \n			\"dbParam\":\"test:test\",\n			\"funParamMap\":{ \n			\"fileName\":\"文件名称\", \n			\"tTitles\":\"id*,名称,姓名\", \n			\"dKeys\":\"id,changeMode,beforeData\"\n			} \n		}\n	], \n	\"dataKeys\":\"\" \n	 \n}', 'file', 'tim', '2021-01-22 10:02:56');
INSERT INTO `sys_api` VALUES ('34ere', 'test', 'runlist', '批量流程测试', '规则1', NULL, NULL, 'task', NULL, '{ \n\"ruleGroup\":\"a\",\r\n\"ruleModule\":\"a\",\r\n\"dataKeys\":\"data>dataMap\"\n}', 'runList', 'tim', '2021-01-22 14:25:43');
INSERT INTO `sys_api` VALUES ('43', 'test', 'test2', 'test2', '测试2批量插入数据', NULL, NULL, 'task', NULL, '{\r\n	\"jobs\":[\r\n		{\r\n			\"fun\":\"baseDb:insertList\",\r\n			\"funParam\":\"\",\r\n			\"resultName\":\"\",\r\n			\"dbParam\":\"\",\r\n			\"funParamMap\":{\r\n			\"listKey\":\"param.list\",\r\n			\"table\":\"test1\",\r\n			\"tableKeys\":\"#id#,abc>changeMode,#cTime#,cc>beforeData\"\r\n			}\r\n		},{\r\n			\"fun\":\"baseDb:insertList\",\r\n			\"funParam\":\"\",\r\n			\"resultName\":\"\",\r\n			\"dbParam\":\"\",\r\n			\"funParamMap\":{\r\n			\"listKey\":\"param.bean.list\",\r\n			\"table\":\"test1\",\r\n			\"tableKeys\":\"#id#,abc>changeMode,#cTime#,cc>beforeData\"\r\n			}\r\n		}\r\n	],\r\n	\"dataKeys\":\"\"\r\n}', 'run', 'tim', '2021-01-13 15:36:48');
INSERT INTO `sys_api` VALUES ('45435', 'test', 'test1', 'test1', '测试1', 'test', 'test', 'task', NULL, NULL, 'list,item,page', 'tim', '2021-01-08 16:03:06');
COMMIT;

-- ----------------------------
-- Table structure for sys_api_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_api_log`;
CREATE TABLE `sys_api_log` (
  `id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `api_group` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '分组',
  `api_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '编号',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '名称',
  `des` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '描述',
  `sql_group` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'sql脚本分组',
  `sql_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'sql脚本code',
  `old_sql_group` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '旧脚本sql脚本分组',
  `old_sql_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '旧脚本sql脚本code',
  `tal` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '标签分类，支持微服务模式',
  `api_param` varchar(3000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'code|name|must  编码|名称|是否必填',
  `old_api_param` varchar(3000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'code|name|must  编码|名称|是否必填',
  `rule_json` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规则',
  `old_rule_json` varchar(4000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规则',
  `model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '允许哪些接口，item,list,page,exe,update',
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '作者',
  `c_time` datetime DEFAULT NULL COMMENT '创建时间',
  `up_time` datetime DEFAULT NULL COMMENT '更新时间',
  `up_author` datetime DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_api_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_t_regular
-- ----------------------------
DROP TABLE IF EXISTS `sys_t_regular`;
CREATE TABLE `sys_t_regular` (
  `ID` varchar(50) NOT NULL,
  `RE_GROUPS` varchar(50) NOT NULL,
  `RE_CODES` varchar(50) DEFAULT NULL,
  `DES` varchar(500) DEFAULT NULL COMMENT '描述',
  `TRUGGER` varchar(300) DEFAULT NULL COMMENT '前置正则条件为空默认执行正则',
  `SEND` varchar(300) DEFAULT NULL COMMENT '被替换的正则',
  `SEND_VALUE` varchar(300) DEFAULT NULL COMMENT '替换的正则',
  `c_time` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_t_regular
-- ----------------------------
BEGIN;
INSERT INTO `sys_t_regular` VALUES ('1', 'text2', 'notNumber', '只能存在数字', '^[\\d]*$', NULL, NULL, NULL);
INSERT INTO `sys_t_regular` VALUES ('2', 'text', 'phone', '手机号', '^[1]([3-9])[0-9]{9}$', NULL, NULL, NULL);
INSERT INTO `sys_t_regular` VALUES ('3', 'text2', 'length20', '长度限制10-20', '^.{10,20}$', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_t_sql
-- ----------------------------
DROP TABLE IF EXISTS `sys_t_sql`;
CREATE TABLE `sys_t_sql` (
  `ID` varchar(50) NOT NULL,
  `GROUPS` varchar(50) NOT NULL COMMENT '组',
  `CODES` varchar(50) NOT NULL COMMENT '编号',
  `SQL_CONTENT` text NOT NULL COMMENT 'sql 脚本',
  `PARAM_KEYS` varchar(255) DEFAULT NULL COMMENT '程序调用参数key 逗号隔开',
  `DES` varchar(400) DEFAULT NULL COMMENT '描述',
  `TAL` varchar(255) DEFAULT NULL COMMENT '标签',
  `C_TIME` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `C_CREATOR` varchar(50) NOT NULL COMMENT '创建人',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sys_t_sql
-- ----------------------------
BEGIN;
INSERT INTO `sys_t_sql` VALUES ('1', 'test', 'test', 'SELECT * from sys_t_sql_log t WHERE 1=1 and t.change_mode = ? and t.before_data= ? and t.after_data LIKE \'%?%\'', NULL, '测试1', 'task', '2021-01-14 11:22:41', 'test');
INSERT INTO `sys_t_sql` VALUES ('1572171309616488448', 'sys-init-xxlJobGroup', 'list', 'select id,app_name,title,order,address_type from xxl_job_group where 1=1  and id=? and app_name=? and title=? and order=? and address_type=?', 'id,appName,title,order,addressType', 'xxl_job_group--list', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309616488449', 'sys-init-xxlJobGroup', 'item', 'select * from xxl_job_group where 1=1  and id=? and app_name=? and title=? and order=? and address_type=?', 'id,appName,title,order,addressType', 'xxl_job_group--item', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309616488450', 'sys-init-xxlJobInfo', 'list', 'select id,job_group,job_cron,job_desc,add_time from xxl_job_info where 1=1  and id=? and job_group=? and job_cron=? and job_desc=? and add_time=?', 'id,jobGroup,jobCron,jobDesc,addTime', 'xxl_job_info--list', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309616488451', 'sys-init-xxlJobInfo', 'item', 'select * from xxl_job_info where 1=1  and id=? and job_group=? and job_cron=? and job_desc=? and add_time=?', 'id,jobGroup,jobCron,jobDesc,addTime', 'xxl_job_info--item', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682752', 'sys-init-xxlJobLock', 'list', 'select lock_name from xxl_job_lock where 1=1  and lock_name=?', 'lockName', 'xxl_job_lock--list', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682753', 'sys-init-xxlJobLock', 'item', 'select * from xxl_job_lock where 1=1  and lock_name=?', 'lockName', 'xxl_job_lock--item', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682754', 'sys-init-xxlJobLog', 'list', 'select id,job_group,job_id,executor_address,executor_handler from xxl_job_log where 1=1  and id=? and job_group=? and job_id=? and executor_address=? and executor_handler=?', 'id,jobGroup,jobId,executorAddress,executorHandler', 'xxl_job_log--list', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682755', 'sys-init-xxlJobLog', 'item', 'select * from xxl_job_log where 1=1  and id=? and job_group=? and job_id=? and executor_address=? and executor_handler=?', 'id,jobGroup,jobId,executorAddress,executorHandler', 'xxl_job_log--item', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682756', 'sys-init-xxlJobLogglue', 'list', 'select id,job_id,glue_type,glue_source,glue_remark from xxl_job_logglue where 1=1  and id=? and job_id=? and glue_type=? and glue_source=? and glue_remark=?', 'id,jobId,glueType,glueSource,glueRemark', 'xxl_job_logglue--list', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682757', 'sys-init-xxlJobLogglue', 'item', 'select * from xxl_job_logglue where 1=1  and id=? and job_id=? and glue_type=? and glue_source=? and glue_remark=?', 'id,jobId,glueType,glueSource,glueRemark', 'xxl_job_logglue--item', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682758', 'sys-init-xxlJobRegistry', 'list', 'select id,registry_group,registry_key,registry_value,update_time from xxl_job_registry where 1=1  and id=? and registry_group=? and registry_key=? and registry_value=? and update_time=?', 'id,registryGroup,registryKey,registryValue,updateTime', 'xxl_job_registry--list', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682759', 'sys-init-xxlJobRegistry', 'item', 'select * from xxl_job_registry where 1=1  and id=? and registry_group=? and registry_key=? and registry_value=? and update_time=?', 'id,registryGroup,registryKey,registryValue,updateTime', 'xxl_job_registry--item', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309620682760', 'sys-init-xxlJobUser', 'list', 'select id,username,password,role,permission from xxl_job_user where 1=1  and id=? and username=? and password=? and role=? and permission=?', 'id,username,password,role,permission', 'xxl_job_user--list', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('1572171309624877056', 'sys-init-xxlJobUser', 'item', 'select * from xxl_job_user where 1=1  and id=? and username=? and password=? and role=? and permission=?', 'id,username,password,role,permission', 'xxl_job_user--item', 'damo', '2022-09-20 18:30:24', 'timSystem');
INSERT INTO `sys_t_sql` VALUES ('2', 'task', 'taskLog', 'SELECT * FROM sys_task_log WHERE 1=1 and c_type= ? LIMIT 100', 'cType', '获取定时任务日志', 'task', '2020-12-30 10:10:37', 'l');
INSERT INTO `sys_t_sql` VALUES ('3', 'phone', 'insert', 'INSERT INTO `task`.`user_list_phone`(`user_phone`, `phone`, `name`) VALUES (?, ?,?)\r\n', 'userPhone,phone,name', '保存通讯录', 'task', '2020-12-23 21:31:11', 'l');
INSERT INTO `sys_t_sql` VALUES ('4', 'rule', 'list', 'SELECT * from rule_list t WHERE 1=1 order by t.order_index ASC', NULL, '获取批量规则数据', 'task', '2021-01-22 14:21:33', 'l');
INSERT INTO `sys_t_sql` VALUES ('5', 'test', 'test1', 'SELECT * from xxl_job_group ', NULL, '测试1', 'task', '2021-01-14 11:22:41', 'test');
COMMIT;

-- ----------------------------
-- Table structure for sys_t_sql_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_t_sql_log`;
CREATE TABLE `sys_t_sql_log` (
  `id` varchar(50) NOT NULL,
  `change_mode` varchar(200) DEFAULT NULL COMMENT '修改模块',
  `before_data` text COMMENT '修改前',
  `after_data` text COMMENT '修改后',
  `c_time` datetime DEFAULT NULL,
  `c_name` varchar(255) DEFAULT NULL COMMENT '修改人账号',
  `c_type` varchar(255) DEFAULT NULL COMMENT 'update or del ',
  `c_groups` varchar(50) DEFAULT NULL COMMENT '对于sql groups',
  `c_codes` varchar(50) DEFAULT NULL COMMENT '对应sql codes',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='sql 管理平台日志记录';

-- ----------------------------
-- Records of sys_t_sql_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_t_sql_log` VALUES ('1', '22', '22', '21', '2020-12-23 16:48:59', '2', '2', '2', '2');
INSERT INTO `sys_t_sql_log` VALUES ('12', 'rewe', 'we', 'qwe', '2020-12-23 17:09:41', '2', '1', '2', '2');
INSERT INTO `sys_t_sql_log` VALUES ('0ba100a8-3079-4d97-a6fe-088f3a01bf6c', 'task', '{\"codes\":\"test\",\"cCreator\":\"l\",\"paramKeys\":\"\",\"des\":\"测试\",\"groups\":\"test\",\"sqlContent\":\"SELECT * from sys_t_sql_log t WHERE 1=1 and t.change_mode = ? and t.before_data= ? and t.after_data LIKE \"%?%\"\",\"cTime\":\"2021-01-05 17:00:13\",\"id\":\"1\",\"tal\":\"task\"}', '{\"codes\":\"test\",\"cCreator\":\"test\",\"paramKeys\":\"\",\"des\":\"测试1\",\"groups\":\"test\",\"sqlContent\":\"SELECT * from sys_t_sql_log t WHERE 1=1 and t.change_mode = ? and t.before_data= ? and t.after_data LIKE \\\"%?%\\\"\",\"cTime\":\"2021-01-14 11:22:41\",\"id\":\"1\",\"tal\":\"task\"}', '2021-01-14 11:22:41', 'test', 'edit', 'test', 'test');
INSERT INTO `sys_t_sql_log` VALUES ('41ace658-a611-4fcc-ac6d-4f5ee56c7caf', 'task', '{\"codes\":\"list\",\"cCreator\":\"timSystem\",\"paramKeys\":\"id,appName,title,order,addressType\",\"des\":\"xxl_job_grouplist\",\"groups\":\"sys-init-xxlJobGroup\",\"sqlContent\":\"select id,app_name,title,order,address_type from xxl_job_group where 1=1 and id=? and app_name=? and title=? and order=? and address_type=?\",\"cTime\":\"2022-09-20 17:30:29\",\"id\":\"1572156231106269184\",\"tal\":\"task\"}', '{\"codes\":\"list\",\"cCreator\":\"test\",\"paramKeys\":\"id,appName,title,order,addressType\",\"des\":\"xxl_job_grouplist\",\"groups\":\"sys-init-xxlJobGroup\",\"sqlContent\":\"select id,app_name,title,order,address_type from xxl_job_group where 1=1 and id=? and app_name=? and title=? and order=?\",\"cTime\":\"2022-09-20 17:35:16\",\"id\":\"1572156231106269184\",\"tal\":\"task\"}', '2022-09-20 17:35:16', 'test', 'edit', 'sys-init-xxlJobGroup', 'list');
COMMIT;

-- ----------------------------
-- Table structure for sys_t_sql_mode
-- ----------------------------
DROP TABLE IF EXISTS `sys_t_sql_mode`;
CREATE TABLE `sys_t_sql_mode` (
  `id` varchar(50) NOT NULL,
  `mode_name` varchar(30) DEFAULT NULL COMMENT '模块名称',
  `mode_code` varchar(20) DEFAULT NULL COMMENT '模块code',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='sql\r\n脚本模块字典';

-- ----------------------------
-- Records of sys_t_sql_mode
-- ----------------------------
BEGIN;
INSERT INTO `sys_t_sql_mode` VALUES ('1', '多端合一', 'witbuild');
INSERT INTO `sys_t_sql_mode` VALUES ('2', '生产经营', 'prodmanage');
INSERT INTO `sys_t_sql_mode` VALUES ('3', '劳务管理', 'labormanage');
INSERT INTO `sys_t_sql_mode` VALUES ('4', '智慧工地', 'witstite');
INSERT INTO `sys_t_sql_mode` VALUES ('5', '智慧工地系统', 'witsiteSystem');
INSERT INTO `sys_t_sql_mode` VALUES ('6', '定时服务器', 'task');
COMMIT;

-- ----------------------------
-- Table structure for sys_task
-- ----------------------------
DROP TABLE IF EXISTS `sys_task`;
CREATE TABLE `sys_task` (
  `ID` varchar(50) NOT NULL COMMENT 'ID',
  `DES` varchar(500) DEFAULT NULL COMMENT '备注',
  `URL` varchar(300) DEFAULT NULL COMMENT 'URL',
  `PARAM` varchar(500) DEFAULT NULL COMMENT '参数',
  `T_GROUPS` varchar(50) DEFAULT NULL COMMENT '分组',
  `T_CODE` varchar(50) DEFAULT NULL COMMENT '编码',
  `C_TIME` datetime DEFAULT NULL COMMENT '创建时间',
  `CREATER` varchar(50) DEFAULT NULL COMMENT '创建人',
  `IS_OPEN` int(11) DEFAULT NULL COMMENT '是否启用',
  `TASK_TIME` varchar(50) DEFAULT NULL COMMENT '任务执行时间',
  `TASK_TYPE` varchar(50) DEFAULT NULL COMMENT '任务类型',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='系统定时任务信息表SYS_TASK';

-- ----------------------------
-- Records of sys_task
-- ----------------------------
BEGIN;
INSERT INTO `sys_task` VALUES ('1', '测试', 'http://www.baidu.com', 'a=1', 'test', 'test', '2020-04-13 19:39:52', '1', 1, '0 * * * * ? *', 'prod');
COMMIT;

-- ----------------------------
-- Table structure for table_nick_name
-- ----------------------------
DROP TABLE IF EXISTS `table_nick_name`;
CREATE TABLE `table_nick_name` (
  `table_name_old` varchar(50) NOT NULL COMMENT '表原名',
  `table_name_nick` varchar(50) NOT NULL COMMENT '表的别名',
  `table_comment` varchar(50) DEFAULT NULL COMMENT '表的描述',
  `C_TIME` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of table_nick_name
-- ----------------------------
BEGIN;
INSERT INTO `table_nick_name` VALUES ('xxl_job_group', 'xxlJobGroup', '', '2022-09-20 18:30:21');
INSERT INTO `table_nick_name` VALUES ('xxl_job_info', 'xxlJobInfo', '', '2022-09-20 18:30:21');
INSERT INTO `table_nick_name` VALUES ('xxl_job_lock', 'xxlJobLock', '', '2022-09-20 18:30:21');
INSERT INTO `table_nick_name` VALUES ('xxl_job_log', 'xxlJobLog', '', '2022-09-20 18:30:21');
INSERT INTO `table_nick_name` VALUES ('xxl_job_logglue', 'xxlJobLogglue', '', '2022-09-20 18:30:21');
INSERT INTO `table_nick_name` VALUES ('xxl_job_registry', 'xxlJobRegistry', '', '2022-09-20 18:30:21');
INSERT INTO `table_nick_name` VALUES ('xxl_job_user', 'xxlJobUser', '', '2022-09-20 18:30:21');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
